<!DOCTYPE html>
<html lang="en">

<head>
  <meta charset="UTF-8">
  <meta http-equiv="X-UA-Compatible" content="IE=edge">
  <link rel="Shortcut Icon" href="../images/aecc.ico" type="image/x-icon" />
  <meta name="viewport" content="width=device-width, initial-scale=1.0">
  <link rel="stylesheet" href="../StaticFiles/element-ui/element-ui.css">
  <link rel="stylesheet" href="../StaticFiles/nprogress/nprogress.min.css">
  <link rel="stylesheet" href="../styles/vue-page-common.css">
  <script src="../Scripts/vue.min.js"></script>
  <script src="../StaticFiles/element-ui/element-ui.js"></script>
  <script src="../Scripts/axios.min.js"></script>
  <script src="../StaticFiles/nprogress/nprogress.min.js"></script>
  <script src="../Scripts/dayjs.min.js"></script>
  <script src="../Scripts/axios.config.js"></script>
  <title>投料统计报表</title>
</head>

<body>
  <div id="app" v-cloak v-on:keyup.enter="getData">
    <!-- 报表标题 -->
    <vue2-report-header :title="'投料统计报表'"></vue2-report-header>
    <div style="padding: 10px;">
      <!-- 查询条件区 -->
      <el-form :inline="true" :model="queryInfo" ref="queryInfoRef" :label-position="'left'" :rules="rules">
        <el-form-item label="主制分厂:" prop="factoryid">
          <el-select v-model="queryInfo.factoryid" placeholder="请选择主制分厂" clearable filterable @change="bindControl">
            <el-option v-for="f in factoryList" :key="f.factoryid" :label="f.factoryname" :value="f.factoryid">
            </el-option>
          </el-select>
        </el-form-item>

        <el-form-item label="机型:">
          <el-select v-model="queryInfo.productfamilyname" placeholder="请选择机型" clearable filterable>
            <el-option v-for="p in productfamilyList" :key="p.productfamilyname" :label="p.productfamilyname"
              :value="p.productfamilyname">
            </el-option>
          </el-select>
        </el-form-item>

        <el-form-item label="到料状态:">
          <el-select v-model="queryInfo.status" placeholder="请选择到料状态" filterable>
            <el-option :key="'未发料'" :label="'未发料'" :value="'未发料'"></el-option>
            <el-option :key="'未到料'" :label="'未到料'" :value="'未到料'"></el-option>
            <el-option :key="'已到料'" :label="'已到料'" :value="'已到料'"></el-option>
          </el-select>
        </el-form-item>

        <el-form-item prop='productname' label="零件图号:">
          <el-autocomplete v-model.trim="queryInfo.productname" placeholder="请输入零件图号" :trigger-on-focus="false"
            style="width:240px;" :fetch-suggestions="searchProductAsync" :value-key="'productname'" :debounce="500">
          </el-autocomplete>
        </el-form-item>

        <el-form-item prop='containername' label="流水卡号:">
          <el-autocomplete v-model.trim="queryInfo.containername" placeholder="请输入流水卡号" :trigger-on-focus="false"
            style="width:240px;" :fetch-suggestions="searchContainerAsync" :value-key="'containername'" :debounce="500">
          </el-autocomplete>
        </el-form-item>

        <el-form-item label="计划员:">
          <el-select v-model="queryInfo.jihuayuan" placeholder="请选择开卡人" clearable filterable>
            <el-option v-for="p in jihuayuanList" :key="p.employeeid" :label="p.fullname" :value="p.employeeid">
            </el-option>
          </el-select>
        </el-form-item>

        <el-form-item label="开卡时间:">
          <el-date-picker v-model="queryInfo.containerstartdate" type="daterange" range-separator="至"
            value-format="yyyy-MM-dd" start-placeholder="开始日期" end-placeholder="结束日期" :picker-options="pickerOptions">
          </el-date-picker>
        </el-form-item>

        <el-form-item label="到料时间:">
          <el-date-picker v-model="queryInfo.daoliaodate" type="daterange" range-separator="至" value-format="yyyy-MM-dd"
            start-placeholder="开始日期" end-placeholder="结束日期" :picker-options="pickerOptions"></el-date-picker>
        </el-form-item>

        <el-popover placement="top-start" title="报表说明:" width="500" trigger="hover">
          <el-button icon="el-icon-info" slot="reference">报表说明</el-button>
          <p>1. 报表只统计在MES批次开卡界面中【是否领料】处勾选了【是】的批次数据。</p>
          <p>2. 过滤批次已关闭数据。</p>
          <h5>到料状态说明：</h5>
          <p>【未发料】: ERP未向MES传递发料数据。</p>
          <p>【已发料】: ERP已向MES传递了发料数据，但还未在MES里进行到料确认。</p>
          <p>【已到料】: 批次已进入在制状态，或已进行了【到料确认】操作。</p>
        </el-popover>

        <el-form-item>
          <el-button type="primary" icon="el-icon-search" size="small" @click="getData">查询</el-button>
          <el-button type="primary" icon="el-icon-download" size="small" @click="getExportExcel">导出</el-button>
        </el-form-item>
      </el-form>

      <!-- 表格显示区 -->
      <el-table v-loading="loading" v-loading.fullscreen.lock="loading" :element-loading-text="loadingText"
        element-loading-background="rgba(0,0,0,0.8)" :data="dataList" stripe border>
        <el-table-column type="index" width="50"></el-table-column>
        <el-table-column label="主制分厂" prop="factoryname" width="120" show-overflow-tooltip></el-table-column>
        <el-table-column label="主制工区" prop="fromworkcentername" width="140"></el-table-column>
        <el-table-column label="机型" prop="familylistnames" width="120" show-overflow-tooltip></el-table-column>
        <el-table-column label="零件图号" prop="productname" width="140" show-overflow-tooltip></el-table-column>
        <el-table-column label="零件名称" prop="productdescription" width="140" show-overflow-tooltip></el-table-column>
        <el-table-column label="流水卡号" prop="containername"></el-table-column>
        <el-table-column label="数量" prop="qty" width="80"></el-table-column>
        <el-table-column label="计划员" prop="fullname" width="80"></el-table-column>
        <el-table-column label="开卡时间" prop="originalstartdate" width="160" :formatter="replaceDate"></el-table-column>
        <el-table-column label="当前投料工序" prop="workflowstepname" width="120"></el-table-column>
        <el-table-column label="到料时间" prop="materialdate" width="160" :formatter="replaceDate"></el-table-column>
      </el-table>

      <!-- 分页组件 -->
      <el-pagination @size-change="handleSizeChange" @current-change="handleCurrentChange"
        :current-page="queryInfo.currentPage" :page-sizes="[12,50,100]" :page-size="queryInfo.pageSize"
        layout="prev,pager,next,jumper,sizes,total" :total="total">
      </el-pagination>

      <!-- 回到顶部 -->
      <el-backtop></el-backtop>
    </div>
  </div>

  <script type="module">
    import { getParams, fetchSuggestion, exportExcelData } from '../Scripts/hooks/useCommonMethod.js'
    import { getFactory, getProductFamily, getFactoryUsersByRoleName, getUserInfo } from '../Scripts/hooks/fetchAPI.js'
    import { prevWeek, thisWeek, nextWeek, prevMonth, thisMonth, nextMonth } from '../Scripts/hooks/useDateShortCut.js'
    import { replaceDate } from '../Scripts/hooks/format.js'
    import Vue2ReportHeader from '../Scripts/components/Vue2ReportHeader.js'
    const app = new Vue({
      el: '#app',
      components: { Vue2ReportHeader },
      data: {
        replaceDate,
        queryInfo: {
          factoryid: '', // 主制分厂
          productfamilyname: '',// 机型
          mfgordername: '', // 订单号
          productname: '',
          containername: '',
          jihuayuan: '', // 计划员
          containerstartdate: '', // 批次开卡时间
          daoliaodate: '', // 到料时间
          status: '未发料', // 状态
          currentPage: 1,//当前页
          pageSize: 12//每页显示条数
        },
        total: 0,
        loading: false,
        loadingText: '数据加载中...',
        dataList: [],
        factoryList: [], // 分厂列表
        productfamilyList: [],// 机型
        jihuayuanList: [],// 计划员
        // 表单验证
        rules: { factoryid: [{ required: true, message: '主制分厂不能为空', trigger: 'change' }] },
        pickerOptions: { shortcuts: [prevWeek, thisWeek, nextWeek, prevMonth, thisMonth, nextMonth] }
      },
      methods: {
        // 查询件号
        searchProductAsync(value, callback) {
          fetchSuggestion({ actionName: 'getProductnameAsync', name: 'productname', value, callback })
        },
        // 查询批次号
        searchContainerAsync(value, callback) {
          fetchSuggestion({ actionName: 'getContainernameAsync', name: 'containername', value, callback })
        },
        async bindControl(factoryid) {
          this.queryInfo.jihuayuan = null;
          if (factoryid) {
            this.jihuayuanList = await getFactoryUsersByRoleName({ factoryid, rolename: '计划员' });
          }
        },
        //查询数据
        async getData() {
          this.$refs['queryInfoRef'].validate(async (valid) => {
            if (!valid) {
              return this.$message.error('必填项不能为空');
            } else {
              this.loading = true;
              this.loadingText = '数据加载中...';
              const { data: { data, meta, total } } = await axios.post('../handler/report/ContainerTouLiaoReport.ashx?action=getData', {
                type: 'getData',
                ...this.queryInfo
              })
              this.loading = false;
              if (meta.status === 500) { return this.$message.error(meta.msg); }
              this.dataList = data;
              this.total = total;
            }
          })
        },
        //导出excel
        async getExportExcel() {
          this.$refs['queryInfoRef'].validate(async (valid) => {
            if (!valid) {
              return this.$message.error('必填项不能为空');
            } else {
              const config = {
                url: '../handler/report/ContainerTouLiaoReport.ashx?action=exportExcel',
                data: { type: 'exportExcel', ...this.queryInfo }
              }
              exportExcelData(config, this);
            }
          })
        },
        handleCurrentChange(newPage) {
          this.queryInfo.currentPage = newPage;
          this.getData();
        },
        handleSizeChange(newSize) {
          this.queryInfo.pageSize = newSize;
          this.getData();
        }
      },
      async mounted() {
        const [factoryList, productfamilyList, userInfo] = await Promise.all([
          getFactory(),
          getProductFamily(),
          getUserInfo({ employeeid: getParams("uid") })
        ]);

        this.factoryList = factoryList;
        this.productfamilyList = productfamilyList;

        const { factoryid } = this.factoryList.some(i => i.factoryid === userInfo.factoryid) ? userInfo : this.factoryList[0];
        this.queryInfo.factoryid = factoryid;
        this.jihuayuanList = await getFactoryUsersByRoleName({ factoryid, rolename: '计划员' });
      },
      watch: { queryInfo: { handler() { this.queryInfo.currentPage = 1 }, deep: true } }
    })
  </script>
</body>

</html>